FundSource

EntityType | Independent
Logical Entity Name | FundSource
Default Table Name | FaFundSource
Logical Only | NO
Owner | dbo
Definition |
Note |

FundSource Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FundSourceId |  | INTEGER | NO |
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(40) | NO |
CampusGroupId |  | INTEGER | NO |
IsTitleIvEligible |  | BIT | NO |
FundSourceType |  | CHAR(8) | NO |
GraceDays |  | NUMERIC(4, 0) | YES |
SAApplySchedID |  | INTEGER | YES |
ThirdPartyCode |  | VARCHAR(20) | YES |
CancelDropDays |  | NUMERIC(3, 0) | YES |
Note |  | TEXT | YES |
IsActive |  | BIT | NO |
IsEft |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
DefaultLendingInstitutionId |  | INTEGER | YES |
DefaultGuarantorId |  | INTEGER | YES |
DefaultServicerId |  | INTEGER | YES |
OverPaymentFlag |  | CHAR(1) | YES |
ReceiptNote |  | TEXT | YES |
IsScheduledDisbursementRequired |  | BIT | NO |
IsSeog |  | BIT | NO |
IsStudentBorrower |  | BIT | NO |
SeogMatchPercentage |  | NUMERIC(5, 2) | YES |
IsManualPostAllowed |  | BIT | NO |
FaGLFundID |  | INTEGER | YES |
NextPaymentDue |  | INTEGER | YES |
RefundPayableTo |  | VARCHAR(150) | YES |
IsDisbDropFlag30Day |  | BIT | YES |
InterestChargeMethod |  | CHAR(1) | YES |
IsInterestRecalc |  | BIT | NO |
IsEditRefund |  | BIT | NO |
IsEditStipend |  | BIT | NO |
IsDisbAmountRounded |  | BIT | NO |
IsIncludedCoa |  | BIT | NO |
IsIncludedRemainingNeed |  | BIT | NO |
IsOtherNonFedResource |  | BIT | YES |
IsIncludedIn1098T |  | BIT | NO |
IsPaymentsAssociatedToCourses |  | BIT | NO |
IsUsedForOutsideCollections |  | BIT | NO |
CollectionsGracePeriod |  | TINYINT | YES |
IsPromissoryNoteAllowed |  | BIT | NO |
IsInterestAppliedFirst |  | BIT | NO |
IsInstitutional |  | BIT | NO |
IsDescriptionCustomizable |  | BIT | NO |
DefaultRefundDescription |  | VARCHAR(100) | YES |
DefaultStipendDescription |  | VARCHAR(100) | YES |
IsScheduledDisbRequired |  | BIT | NO |
ReserveRate2009For9010Report |  | DECIMAL(7, 3) | YES |
ReserveRate2010For9010Report |  | DECIMAL(7, 3) | YES |
ReserveRate2011For9010Report |  | DECIMAL(7, 3) | YES |
ReserveRate2012For9010Report |  | DECIMAL(7, 3) | YES |
IsInstitutionalScholarshipOrGrant |  | BIT | NO |
IsRequiredToTakeAttendance |  | BIT | NO |
IsExcludedFromEstimatedAid |  | BIT | NO |
UsaStateId |  | INTEGER | YES |
NeedBased |  | CHAR(1) | NO |
IsMilitaryTA |  | BIT | NO |
IsMilitaryVA |  | BIT | NO |
IsNonTaxable |  | BIT | NO |
IsFoundation |  | BIT | NO |
IsMeritBased |  | BIT | NO |
ContactAddress |  | VARCHAR(255) | YES |
ContactCity |  | CHAR(35) | YES |
ContactState |  | CHAR(2) | YES |
ContactPostalCode |  | CHAR(10) | YES |
ContactPhoneNumber |  | VARCHAR(16) | YES |
IsAutoApprovedOnCreate |  | BIT | NO |
IsApprovedByStudentOnPortal |  | BIT | NO |
IsRestrictMinPayment |  | BIT | NO |
IsTila |  | BIT | NO |
IsIncludedInDirectLoan9010Report |  | BIT | YES |
IsServiceRequired |  | BIT | NO |
IsTitleViiEligible |  | BIT | NO |
NoelLevitzSource |  | CHAR(1) | NO |
NoelLevitzBasis |  | CHAR(1) | NO |
NoelLevitzFunding |  | CHAR(1) | NO |
NoelLevitzAwardType |  | CHAR(1) | NO |
IsAvailableSummerTermAwarding |  | BIT | NO |
IsPaymentAutoCreated |  | BIT | NO |
AutoPaymentDueBy |  | TINYINT | NO |
AutoPaymentDays |  | INTEGER | NO |
IsStipendPostingForNonDisbursedFunds |  | BIT | NO |
IsOtherOutsideGrant |  | BIT | NO |
IsCrossOverPellAllowed |  | BIT | NO |

FundSource Keys

Key Name | Key Type | Keys
Nk_FaFundSource_SyStateID | Inversion Entry | UsaStateId
FaFundSource_Type_N_N_IDX | Inversion Entry | FundSourceType
FaFundSource_FaGLFundID_N_N_IDX | Inversion Entry | FaGLFundID
FaFundSource_faFundSourceID_U_C_IDX | PrimaryKey | FundSourceId

FundSource Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
FaGLFund | Non-Identifying | Zero or One to Zero or More |  |  |  | FaGLFundID | NO
FundSourceType | Non-Identifying | One To Zero or More |  |  |  | FundSourceType | NO
UsaState | Non-Identifying | Zero or One to Zero or More |  |  |  | UsaStateId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
Agency | Non-Identifying | One To Zero or More |  |  |  |  | NO
CmActionsFundSourceDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
FundSourceDisabledAwardYear | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutoAwardPaymentPlanSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCfpFundsourceConfig_Regulatory | Non-Identifying | One To Zero or More |  |  |  |  | NO
DisbursementApprovalRuleCampusFundSource | Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardEstimate | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaFundSourceAutoAwardRules | Non-Identifying | One To Zero or More |  |  |  |  | NO
FundSourceLendingInstitution | Identifying | One To Zero or More |  |  |  |  | NO
FaFundSourcePriority | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaMultiDisbSchedRuleCriteria | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProgramVersionNonTitleIvPaymentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAward | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAwardNonTitleIvRule | Non-Identifying | One To Zero or More |  |  |  |  | NO
BankAccountFundSource | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaCreditSourceApplyOrder | Non-Identifying | One To Zero or More |  |  |  |  | NO
SaFundSourceOrder | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionAppliedPayment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransactionConfigureAppliedPayment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StaffGroupFundSourcePermission | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyServiceExceptionSuspendHoldGrpFundSource | Non-Identifying | One To Zero or More |  |  |  |  | NO
StateReportConfigurationSettingFundSource | Non-Identifying | One To Zero or More |  |  |  |  | NO
RefundCalculationPolicyOrderReturnFund | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRefundCalculationFundSourceSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRt4CalculationStudentAward | Non-Identifying | One To Zero or More |  |  |  |  | NO

FundSource Check Constraints

Check Constraint Name | CheckConstraint

FundSource Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FundSource | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaFundSource | NO |  |  |

FundSource Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | RefundCalculation
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FundSource Data Movement Rules

Name | Type | Rule Text/Value